how to move stored procedures from one database to another ? Right Click on the database -> Tasks -> Generate Scripts